package com.ruoyi.statisticalCenter.domain;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.ruoyi.logistic.domain.NetworkClient;
import com.ruoyi.logistic.domain.NetworkName;
import lombok.Data;

import java.io.Serializable;
import java.math.BigDecimal;

//出港返利毛利表
@Data
public class ScOutReturnSheet implements Serializable {
    private static final long serialVersionUID = -3815472500304640273L;

    /**
     * 应收总部金额
     */

    @ExcelProperty("名称")
    private String name;

    @ExcelProperty("日期")
    private String date;

    @ExcelProperty("0-0.5kg分档返利-发件数")
    private Integer zeroToHalfKgShipments;
    @ExcelProperty("0-0.5kg分档返利-占比")
    private BigDecimal zeroToHalfKgPercentage;
    @ExcelProperty("0-0.5kg分档返利-剔除票数")
    private Integer zeroToHalfKgEliminateNum;
    @ExcelProperty("0-0.5kg分档返利-符合政策票数")
    private Integer zeroToHalfKgPolicyQualified;
    @ExcelProperty("0-0.5kg分档返利-返利标准")
    private BigDecimal zeroToHalfKgRebateStandard;
    @ExcelProperty("0-0.5kg分档返利-金额")
    private BigDecimal zeroToHalfKgAmount;

    @ExcelProperty("0.5-1kg分档返利-发件数")
    private Integer halfTo1KgShipments;
    @ExcelProperty("0.5-1kg分档返利-占比")
    private BigDecimal halfTo1KgPercentage;
    @ExcelProperty("0.5-1kg分档返利-剔除票数")
    private Integer halfTo1KgEliminateNum;
    @ExcelProperty("0.5-1kg分档返利-符合政策票数")
    private Integer halfTo1KgPolicyQualified;
    @ExcelProperty("0.5-1kg分档返利-返利标准")
    private BigDecimal halfTo1KgRebateStandard;
    @ExcelProperty("0.5-1kg分档返利-金额")
    private BigDecimal halfTo1KgAmount;

    @ExcelProperty("1-3kg分档返利-发件数")
    private Integer oneTo3KgShipments;
    @ExcelProperty("1-3kg分档返利-占比")
    private BigDecimal oneTo3KgPercentage;
    @ExcelProperty("1-3kg分档返利-剔除票数")
    private Integer oneTo3KgEliminateNum;
    @ExcelProperty("1-3kg分档返利-符合政策票数")
    private Integer oneTo3KgPolicyQualified;
    @ExcelProperty("1-3kg分档返利-返利标准")
    private BigDecimal oneTo3KgRebateStandard;
    @ExcelProperty("1-3kg分档返利-金额")
    private BigDecimal oneTo3KgAmount;

    @ExcelProperty("3-10kg分档返利-发件数")
    private Integer threeToTenKgShipments;
    @ExcelProperty("3-10kg分档返利-占比")
    private BigDecimal threeToTenKgPercentage;
    @ExcelProperty("3-10kg分档返利-剔除票数")
    private Integer threeToTenKgEliminateNum;
    @ExcelProperty("3-10kg分档返利-符合政策票数")
    private Integer threeToTenKgPolicyQualified;
    @ExcelProperty("3-10kg分档返利-返利标准")
    private BigDecimal threeToTenKgRebateStandard;
    @ExcelProperty("3-10kg分档返利-金额")
    private BigDecimal threeToTenKgAmount;

    @ExcelProperty("10-399kg分档返利-发件数")
    private Integer tenTo399KgShipments;
    @ExcelProperty("10-399kg分档返利-占比")
    private BigDecimal tenTo399KgPercentage;
    @ExcelProperty("10-399kg分档返利-返利标准")
    private BigDecimal tenTo399KgRebateStandard;
    @ExcelProperty("10-399kg分档返利-金额")
    private BigDecimal tenTo399KgAmount;

    @ExcelProperty("叠加返利1-3kg-发件数")
    private Integer xoverlayPolicyOneTo3KgShipments;
    @ExcelProperty("叠加返利1-3kg-日基数")
    private Integer xoverlayPolicyOneTo3KgBase;
    @ExcelProperty("叠加返利1-3kg-剔除票数")
    private Integer xoverlayPolicyOneTo3KgPolicyQualified;
    @ExcelProperty("叠加返利1-3kg-符合政策票数")
    private Integer xoverlayPolicyOneTo3KgRebateStandard;
    @ExcelProperty("叠加返利1-3kg-返利标准")
    private BigDecimal xoverlayPolicyOneTo3KgPercentage;
    @ExcelProperty("叠加返利1-3kg-金额")
    private BigDecimal xoverlayPolicyOneTo3KgAmount;

    //
    @ExcelProperty("增量返利0-1kg-发件数")
    private Integer incrementalRebate0To1KgShipmentCount;
    //
    @ExcelProperty("增量返利0-1kg-日基数")
    private Integer incrementalRebate0To1KgDailyBasis;
    //
    @ExcelProperty("增量返利0-1kg-剔除票数")
    private Integer incrementalRebate0To1KgExcludeTickets;
    //
    @ExcelProperty("增量返利0-1kg-符合政策票数")
    private Integer incrementalRebate0To1KgPolicyCompliantTickets;
    //
    @ExcelProperty("增量返利0-1kg-返利标准")
    private BigDecimal incrementalRebate0To1KgRebateStandard;
    //
    @ExcelProperty("增量返利0-1kg-金额")
    private BigDecimal incrementalRebate0To1KgAmount;

    //
    @ExcelProperty("0-2kg叠加返利-发件数")
    private Integer cumulativeRebate0To2KgShipmentCount;
    //
    @ExcelProperty("0-2kg叠加返利-日基数")
    private Integer cumulativeRebate0To2KgDailyBasis;
    //
    @ExcelProperty("0-2kg叠加返利-剔除票数")
    private Integer cumulativeRebate0To2KgExcludeTickets;
    //
    @ExcelProperty("0-2kg叠加返利-符合政策票数")
    private Integer cumulativeRebate0To2KgPolicyCompliantTickets;
    //
    @ExcelProperty("0-2kg叠加返利-返利标准")
    private BigDecimal cumulativeRebate0To2KgRebateStandard;
    //
    @ExcelProperty("0-2kg叠加返利-金额")
    private BigDecimal cumulativeRebate0To2KgAmount;

    //
    @ExcelProperty("0-1kg阶梯考核-发件数")
    private Integer tieredAssessment0To1KgShipmentCount;
    //
    @ExcelProperty("0-1kg阶梯考核-日业务量")
    private Integer tieredAssessment0To1KgDailyVolume;
    //
    @ExcelProperty("0-1kg阶梯考核-考核业务量")
    private Integer tieredAssessment0To1KgAssessedVolume;
    //
    @ExcelProperty("0-1kg阶梯考核-不足业务量")
    private Integer tieredAssessment0To1KgInsufficientVolume;
    //
    @ExcelProperty("0-1kg阶梯考核-考核标准")
    private BigDecimal tieredAssessment0To1KgAssessmentStandard;
    //
    @ExcelProperty("0-1kg阶梯考核-金额")
    private BigDecimal tieredAssessment0To1KgAmount;
    

    @ExcelProperty("0-999kg散单考核-发件数")
    private Integer throwawayAssessment0To999KgShipmentCount;
    //
    @ExcelProperty("0-999kg散单考核-日业务量")
    private Integer throwawayAssessment0To999KgDailyVolume;
    //
    @ExcelProperty("0-999kg散单考核-考核业务量")
    private Integer throwawayAssessment0To999KgAssessedVolume;
    //
    @ExcelProperty("0-999kg散单考核-不足业务量")
    private Integer throwawayAssessment0To999KgInsufficientVolume;
    //
    @ExcelProperty("0-999kg散单考核-考核标准")
    private BigDecimal throwawayAssessment0To999KgAssessmentStandard;
    //
    @ExcelProperty("0-999kg散单考核-金额")
    private BigDecimal throwawayAssessment0To999KgAmount;

    
    //
    @ExcelProperty("0-999kg业务考核-发件数")
    private Integer businessAssessment0To999KgShipmentCount;
    //
    @ExcelProperty("0-999kg业务考核-日业务量")
    private Integer businessAssessment0To999KgDailyVolume;
    //
    @ExcelProperty("0-999kg业务考核-考核业务量")
    private Integer businessAssessment0To999KgAssessedVolume;
    //
    @ExcelProperty("0-999kg业务考核-不足业务量")
    private Integer businessAssessment0To999KgInsufficientVolume;
    //
    @ExcelProperty("0-999kg业务考核-考核标准")
    private BigDecimal businessAssessment0To999KgAssessmentStandard;
    //
    @ExcelProperty("0-999kg业务考核-金额")
    private BigDecimal businessAssessment0To999KgAmount;

    //
    @ExcelProperty("发件票数合计")
    private Integer totalShipments;
    //
    @ExcelProperty("返利金额合计")
    private BigDecimal totalRebateAmount;
    //
    @ExcelProperty("应收总部金额-单票返利")
    private BigDecimal singleTicketRebate;
    //
    @ExcelProperty("剔除数调整")
    private BigDecimal exclusionAdjustment;

    //
    @ExcelProperty("应收总部金额-1-3kg一客一价返利-发件数")
    private Integer oneToThreeKgRebateShipmentCountReceipt;
    //
    @ExcelProperty("应收总部金额-1-3kg一客一价返利-日业务量")
    private Integer oneToThreeKgRebateDailyVolumeReceipt;
    //
    //@ExcelProperty("应收总部金额-1-3kg一客一价返利-考核业务量")
    @ExcelIgnore
    private Integer oneToThreeKgRebateAssessedVolumeReceipt;
    //
    @ExcelProperty("应收总部金额-1-3kg一客一价返利-返利业务量")
    private Integer oneToThreeKgRebateRebateVolumeReceipt;
    //
    @ExcelProperty("应收总部金额-1-3kg一客一价返利-返利标准")
    private BigDecimal oneToThreeKgRebateRebateStandardReceipt;
    //
    @ExcelProperty("应收总部金额-1-3kg一客一价返利-一客一价金额")
    private BigDecimal oneToThreeKgRebateAmountReceipt;

    //
    @ExcelProperty("总部净返利合计")
    private BigDecimal headquartersNetRebateTotal;

    @ExcelProperty("0-0.5kg超基数返利-符合政策票")
    private Integer zeroToHalfKgExceedBasePolicyQualified;
    @ExcelProperty("0-0.5kg超基数返利-基数")
    private Integer zeroToHalfKgExceedBasePolicyBase;
    @ExcelProperty("0-0.5kg超基数返利-返利票数")
    private Integer zeroToHalfKgExceedBasePolicyDifference;
    @ExcelProperty("0-0.5kg超基数返利-返利标准")
    private BigDecimal zeroToHalfKgExceedBasePolicyRebateStandard;
    @ExcelProperty("0-0.5kg超基数返利-返利")
    private BigDecimal zeroToHalfKgExceedBasePolicyRebate;
    @ExcelProperty("0-0.5kg超基数返利-毛利")
    private BigDecimal zeroToHalfKgExceedBasePolicyGrossProfit;

    @ExcelProperty("0.5-1kg超基数返利-符合政策票")
    private Integer halfTo1KgExceedBasePolicyQualified;
    @ExcelProperty("0.5-1kg超基数返利-基数")
    private Integer halfTo1KgExceedBasePolicyBase;
    @ExcelProperty("0.5-1kg超基数返利-差额")
    private Integer halfTo1KgExceedBasePolicyDifference;
    @ExcelProperty("0.5-1kg超基数返利-返利标准")
    private BigDecimal halfTo1KgExceedBasePolicyRebateStandard;
    @ExcelProperty("0.5-1kg超基数返利-返利")
    private BigDecimal halfTo1KgExceedBasePolicyRebate;
    @ExcelProperty("0.5-1kg超基数返利-毛利")
    private BigDecimal halfTo1KgExceedBasePolicyGrossProfit;

    @ExcelProperty("1-3kg分档返利-符合政策票")
    private Integer oneTo3KgRebatePolicyQualified;
    @ExcelProperty("1-3kg分档返利-返利标准")
    private BigDecimal oneTo3KgRebatePolicyRebateStandard;
    @ExcelProperty("1-3kg分档返利-返利")
    private BigDecimal oneTo3KgRebatePolicyRebate;
    @ExcelProperty("1-3kg分档返利-毛利")
    private BigDecimal oneTo3KgRebatePolicyGrossProfit;

    @ExcelProperty("3-999kg分档返利-符合政策票")
    private Integer threeTo999KgRebatePolicyQualified;
    @ExcelProperty("3-999kg分档返利-返利标准")
    private BigDecimal threeTo999KgRebatePolicyRebateStandard;
    @ExcelProperty("3-999kg分档返利-返利")
    private BigDecimal threeTo999KgRebatePolicyRebate;
    @ExcelProperty("3-999kg分档返利-毛利")
    private BigDecimal threeTo999KgRebatePolicyGrossProfit;

    @ExcelProperty("1-3kg叠加返利-符合政策票数")
    private Integer oneToThreeKgAdditiveRebateCompliantTickets;
    //
    @ExcelProperty("1-3kg叠加返利-返利标准")
    private BigDecimal oneToThreeKgAdditiveRebateStandard;
    //
    @ExcelProperty("1-3kg叠加返利-返利")
    private BigDecimal oneToThreeKgAdditiveRebate;
    //
    @ExcelProperty("1-3kg叠加返利-毛利")
    private BigDecimal oneToThreeKgAdditiveGrossProfit;

    //
    @ExcelProperty("0-2kg叠加返利-符合政策票数")
    private Integer zeroToTwoKgAdditiveRebateCompliantTickets;
    //
    @ExcelProperty("0-2kg叠加返利-返利标准")
    private BigDecimal zeroToTwoKgAdditiveRebateStandard;
    //
    @ExcelProperty("0-2kg叠加返利-返利")
    private BigDecimal zeroToTwoKgAdditiveRebate;
    //
    @ExcelProperty("0-2kg叠加返利-毛利")
    private BigDecimal zeroToTwoKgAdditiveGrossProfit;

    //
    @ExcelProperty("应付承包区金额-1-3kg一客一价返利-发件数")
    private Integer oneToThreeKgRebateShipmentCount;
    //
    @ExcelProperty("应付承包区金额-1-3kg一客一价返利-日业务量")
    private Integer oneToThreeKgRebateDailyVolume;
    //
    //@ExcelProperty("应付承包区金额-1-3kg一客一价返利-考核业务量")
    @ExcelIgnore
    private Integer oneToThreeKgRebateAssessedVolume;
    //
    @ExcelProperty("应付承包区金额-1-3kg一客一价返利-返利业务量")
    private Integer oneToThreeKgRebateRebateVolume;
    //
    @ExcelProperty("应付承包区金额-1-3kg一客一价返利-返利标准")
    private BigDecimal oneToThreeKgRebateRebateStandard;
    //
    @ExcelProperty("应付承包区金额-1-3kg一客一价返利-返利")
    private BigDecimal oneToThreeKgRebateRebate;
    //
    @ExcelProperty("应付承包区金额-1-3kg一客一价返利-毛利")
    private BigDecimal oneToThreeKgRebateGrossProfit;
    //
    @ExcelProperty("支付承包区返利合计")
    private BigDecimal paymentContractAreaRebateTotal;
    //
    @ExcelProperty("应付承包区金额-单票返利")
    private BigDecimal singleTicketRebateTotal;
    //
    @ExcelProperty("返利毛利")
    private BigDecimal rebateGrossProfit;


}
